Executive summary 3



Troubles that occurred During Project
1. Pointer KPIsCreating Upward and Downward Pointer for the KPIs took me time to find out the workaround, I had to create 2 measures one for the pointer to be up or down, the second measure was for the coloring condition, and it worked great

2. Incomplete dataset: the data set was incomplete; I had to fill up the gaps as certain accidents didn’t have data and the other complementary information required to produce an informative dashboard.

3. Dax and measure: I had to create a series of Dax measures and calculated columns to build this dashboard; lots of research helped me too in achieving this thing.

Lead more on common challenges encountered while building a dashboard in power bi and how to overcome them

https://www.knowledgehut.com/blog/business-intelligence-and-visualization/power-bi-limitations  

Executive summary 3



Troubles that occurred During Project
1. Pointer KPIsCreating Upward and Downward Pointer for the KPIs took me time to find out the workaround, I had to create 2 measures one for the pointer to be up or down, the second measure was for the coloring condition, and it worked great

2. Incomplete dataset: the data set was incomplete; I had to fill up the gaps as certain accidents didn’t have data and the other complementary information required to produce an informative dashboard.

3. Dax and measure: I had to create a series of Dax measures and calculated columns to build this dashboard; lots of research helped me too in achieving this thing.

Lead more on common challenges encountered while building a dashboard in power bi and how to overcome them

https://www.knowledgehut.com/blog/business-intelligence-and-visualization/power-bi-limitations